MD - Monitor Agency Role
------------------------

This transaction defines which agencies have which administrative roles associated with a monitor.


Rules
^^^^^

A Reporting Organization assignment cannot be changed, (i.e., updated or deleted), in a manner that would exclude any existing raw, blank, or QA data, up to 2006-12-31.

A Reporting Organization assignment for a production monitor cannot be changed, (i.e., updated or deleted), in a manner that leave any portion of that monitor's sample periods, up to 2006-12-31, without a Reporting Organization.

A PQAO assignment for a production monitor cannot be changed, (i.e., updated or deleted), in a manner that leave any portion of that monitor's sample periods since 2007-01-01 without a PQAO.
Error Messages:

A PQAO assignment cannot be created for any period preceding 2007-01-01.

Examples:

.. code-block:: text
   :caption: MD transaction block in default mode

   MD|I|06|001|0007|88101|3|COLLECTING|0086|20110101|
   MD|I|06|001|0007|88101|3|REPORTING|0086|20110101|
   MD|I|06|001|0007|88101|3|CERTIFYING|0086|20110101|
   MD|I|06|001|0007|88101|3|PQAO|0086|20110101|
   MD|I|06|001|0007|88101|3|ANALYZING|0086|20110101|

.. code-block:: text
   :caption: MD transaction block in Tribal mode

   MD|I|TT|614|7004|81102|1|COLLECTING|614|20020701|
   MD|I|TT|614|7004|81102|1|REPORTING|614|20020701|
   MD|I|TT|614|7004|81102|1|CERTIFYING|614|20020701|
   MD|I|TT|614|7004|81102|1|PQAO|614|20020701|



Format
^^^^^^

.. list-table:: MD - Monitor Agency Role transaction format
   :widths: 1 5 15 4 3 1
   :header-rows: 1


   * - Seq.
     - Name
     - Description
     - Formatting Rules
     - Required
     - Key
   * - 1
     - `Transaction Type <Transaction%20Type.html>`_
     - Monitor Agency Role transaction identifier.
     - Must = MD
     - Always
     - 
   * - 2
     - `Action Indicator <Action%20Indicator%20for%20Transaction.html>`_
     - Indicator for Insert, Update, or Delete action.
     - Must = I, U, or D
     - Always
     - 
   * - 3
     - `State Code / Tribal Indicator <State%20Code.html>`_
     - The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code.
     - Must exist in STATES Reference Table or be 'TT' for Tribal Site
     - Always
     - Y
   * - 4
     - `County Code / Tribal Code <County%20Code.html>`_
     - The FIPS County Code of the site.  If the previous field on the transaction contains "TT", then the Tribal Code of the site.
     - Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
     - Always
     - Y
   * - 5
     - `Site Number <Site%20Number.html>`_
     - Four digit number to uniquely identify site in county and/or tribe.
     - Must exist in SITES table with {State Code, county Code} or Tribal Code
     - Always
     - Y
   * - 6
     - `Parameter Code <Parameter%20Code.html>`_
     - The AQS parameter code assigned to the monitor in AQS.
     - Must exist in PARAMETERS reference table.
     - Always
     - Y
   * - 7
     - `POC <POC.html>`_
     - Parameter Occurrence Code:  One or two digit number identifying a specific monitor for a parameter at the site.  
     - Must exist in MONITOR table for non-Insert actions.
     - Always
     - Y
   * - 8
     - `Agency Role <Agency%20Role.html>`_
     - Classification of the role of an agency with regard to the monitor.
     - Must exist in AGENCY ROLES reference table.
     - Insert
     - Y
   * - 9
     - `Agency Code <Agency%20Code.html>`_
     - Code representing the agency given the role.
     - Must exist in AGENCIES reference table.
     - Always
     - Y
   * - 10
     - `Agency Role Begin Date <Agency%20Role%20Begin%20Date.html>`_
     - Date the role took effect.
     - YYYYMMDD.
     - Insert
     - Y
   * - 11
     - `Agency Role End Date <Agency%20Role%20End%20Date.html>`_
     - Date the role ceased being in effect.
     - YYYYMMDD.
     - No
     -